<!DOCTYPE html>
<html lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<meta charset="utf-8">
<title></title>
<meta name="viewport"
	content="width=device-width, initial-scale=1.0, maximum-scale=1, user-scalable=no">
<meta name="description" content="">
<meta name="author" content="">
<!-- STYLESHEETS -->
<!--[if lt IE 9]><script src="../../js/flot/excanvas.min.js"></script><script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script><script src="http://css3-mediaqueries-js.googlecode.com/svn/trunk/css3-mediaqueries.js"></script><![endif]-->
<link rel="stylesheet" type="text/css" href="../../css/cloud-admin.css">
<link rel="stylesheet" type="text/css" href="../../css/themes/default.css" id="skin-switcher">
<link rel="stylesheet" type="text/css" href="../../css/responsive.css">
<link href="../../font-awesome/css/font-awesome.min.css" rel="stylesheet">
<!-- SELECT2 -->
<link rel="stylesheet" type="text/css" href="../../js/select2/select2.min.css" />
<!-- UNIFORM -->
<link rel="stylesheet" type="text/css" href="../../js/uniform/css/uniform.default.min.css" />
<!-- datatable -->
<link rel="stylesheet" href="../../js/datatables/datatable.css">
<link rel="stylesheet" href="../../js/datepicker/datepicker.css">

</head>
<body>
	<header class="navbar clearfix" id="header"> </header>

	<!-- PAGE -->
	<section id="page">
		<!-- SIDEBAR -->
		<div id="sidebar" class="sidebar">
			<div class="sidebar-menu nav-collapse">

				<!-- SIDEBAR MENU -->
				<ul>
				</ul>
			</div>


		</div>
		<!-- /SIDEBAR -->
		<div id="main-content">
	<div class="modal fade" id="shop_config" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
					<div class="modal-dialog">
						<div class="modal-content">
							<div class="modal-header">
								<button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
								<h4 class="modal-title">按店铺</h4>
							</div>
							<div class="modal-body">								
								<table class="table table-bordered skus">
									<thead>
									<tr>									
									<th>店铺名称</th>
									<th style="width:100px">销量</th>								
									</tr>
									</thead>
									<tbody>									
									</tbody>									
									</table>
							</div>
							
							<div class="modal-footer">
								<button type="button" class="btn btn-default" data-dismiss="modal">取消</button>
								
							</div>
						</div>
					</div>
				</div>
					<div class="modal fade" id="sku_config" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
					<div class="modal-dialog">
						<div class="modal-content">
							<div class="modal-header">
								<button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
								<h4 class="modal-title">按尺码</h4>
							</div>
							<div class="modal-body">
								<table class="table table-bordered skus">
									<thead>
									<tr>									
									<th>尺码</th>
									<th style="width:100px">销量</th>								
									<th style="width:100px">可发库存</th>								
									<th style="width:100px">采购量</th>								
									</tr>
									</thead>
									<tbody>									
									</tbody>									
									</table>
							</div>
							
							<div class="modal-footer">
								<button type="button" class="btn btn-default" data-dismiss="modal">取消</button>
								
							</div>
						</div>
					</div>
				</div>
			<div class="container">
				<div class="row">
					<div id="content" class="col-lg-12">
						<!-- PAGE HEADER-->
						<div class="row">
							<div class="col-sm-12">
								<div class="page-header">
									<!-- STYLER -->

									<!-- /STYLER -->
									<!-- BREADCRUMBS -->
									<ul class="breadcrumb">
										<li>
											<i class="fa fa-home"></i>
											<a href="index.html">首页</a>
										</li>
										<li>
											<a href="#">营销管理</a>
										</li>
										<li>优惠劵</li>
									</ul>
									<!-- /BREADCRUMBS -->

								</div>
							</div>
						</div>
						<!-- /PAGE HEADER -->
						<!-- FORMS QUERY-->
						<div class="row">
							<div class="col-md-12">
								<div class="row">
									<div class="col-md-12">
										<div class="box border primary">
											<div class="box-title">
												<h4>
													<i class="fa fa-bars"></i>
													查询条件
												</h4>
											</div>
											<div class="box-body big" style="padding: 10px;">
												<form class="form-horizontal" role="form" id="form_Order" action="../../admin/report/exportProductReport.do">
													<div class="form-group mrg-bt10">
												   <label class="col-sm-1 control-label" style="width: auto">商品名称：</label>
												   <div class="col-sm-2" >
														 <input type="text" name="q"  class="form-control" placeholder="输入关键字">
													</div>
													<label class="control-label col-md-1" style="line-height:34px;">店铺：</label>
													<div class="col-md-2">
														<select  id="shopNo_select" name="shopNo" class="col-md-12 select2-offscreen" tabindex="-1">
														<option value='-1'>选择店铺</option>
														<option value='002'>壹果微信</option>
														<option value='024'>天猫</option>
														<option value='001'>淘宝</option>
	
														</select>
													</div>
													<label class="col-sm-1 control-label" style="width: auto">销售区间：</label>
													<div class="col-sm-4" style="display:inline-flex;margin-left:-10px">
													<div class="col-sm-2" style="width:130px">
														 <input type="text" name="startDate"  class="form-control bootstrap-datepicker">
													</div>
													<div style="width: 20px">至</div>
														<div class="float-left" style="width:130px">
															 <input type="text" name="endDate" class="form-control bootstrap-datepicker">
														</div>	
													</div>
													</div>
													<div class="form-group mrg-bt10">
													<label class="col-sm-1 control-label" style="width: auto">上架日期：</label>
													<div class="col-sm-4" style="display:inline-flex;margin-left:-10px">
													<div class="col-sm-2" style="width:130px">
														 <input type="text" name="salesStartDate"  class="form-control bootstrap-datepicker">
													</div>
													<div style="width: 20px">至</div>
														<div class="float-left" style="width:130px">
															 <input type="text" name="salesEndDate" class="form-control bootstrap-datepicker">
														</div>	
													</div>
																	 									
													<div class="col-sm-1">
									       				<a class="btn btn-primary search">查询</a>
													</div>
								                 </div>
												</form>
											</div>
										</div>
									</div>
								</div>


							</div>
						</div>
						<!-- /FORMS QUERY -->
<div class="row" style="height: 30px;">
								<div class="col-md-12">
									<div class="box ">
										<a href="javaScript:;"  class="btn btn-success export" >
											<i class="fa  fa-plus-square-o"></i> 导出数据
										</a>
										<span style="color:red">8月份以后的数据为全站销售数据(含退货),8月份之前为M站数据,每1小时更新一次</span>
									</div>
								</div>
					    </div>
						<div class="row">
							<!-- TABLES -->
							<div class="col-md-12">
								<!-- BOX -->
								<div class="box border primary">
									<div class="box-title">
										<h4>
											<i class="fa fa-table"></i>
											记录数：
											<span id="total"></span>
											条
										</h4>

									</div>
									<div class="box-body">
										<table id="db_report_list" cellpadding="0" cellspacing="0" border="0"
											class="datatable table table-striped table-bordered table-hover">

										</table>
									</div>
								</div>
								<!-- /BOX -->
							</div>
						</div>
						<!-- /TABLES -->


						<div class="footer-tools">
							<span class="go-top">
								<i class="fa fa-chevron-up"></i>
								Top
							</span>
						</div>
					</div>
					<!-- /CONTENT-->
				</div>
			</div>
		</div>
	</section>
	<!--/PAGE -->
	<!-- JAVASCRIPTS -->
	<!-- Placed at the end of the document so the pages load faster -->
	<!-- JQUERY -->
	<script src="../../js/jquery/jquery-2.0.3.min.js"></script>
	<!-- spinner -->
	<script src="../../js/spinner/spin.js"></script>
	<!-- BOOTSTRAP -->
	<script src="../../bootstrap-dist/js/bootstrap.min.js"></script>
	<!-- BLOCK UI -->
	<script type="text/javascript" src="../../js/jQuery-BlockUI/jquery.blockUI.min.js"></script>

	<!-- AUTOSIZE -->
	<script type="text/javascript" src="../../js/autosize/jquery.autosize.min.js"></script>
	<!-- DATA TABLES -->
	<script type="text/javascript" src="../../js/datatables/bootstrap-select.js"></script>
	<script type="text/javascript" src="../../js/datatables/datatable.js"></script>
	<script type="text/javascript" src="../../js/datatables/datatable-bootstrap.js"></script>
	<script type="text/javascript" src="../../js/datatables/datatable-tabletools.js"></script>
	<script type="text/javascript" src="../../js/datatables/fnAddTr.js"></script>
	<script type="text/javascript" src="../../js/datepicker/datepicker.js"></script>
	<!-- SELECT2 -->
	<script type="text/javascript" src="../../js/select2/select2.min.js"></script>
	<!-- UNIFORM -->
	<script type="text/javascript" src="../../js/uniform/jquery.uniform.min.js"></script>
	<!-- COOKIE -->
	<script type="text/javascript" src="../../js/jQuery-Cookie/jquery.cookie.min.js"></script>
	<!-- CUSTOM SCRIPT -->
	<script src="../../js/script.js"></script>
	<script src="../../js/common.js"></script>
	<script>
		var Report = function() {
			var $mainDataTable = null;

			var searchData = function() {

				var productName = $("input[name=q]").val();
				var startDate = $("input[name=startDate]").val();
				var endDate = $("input[name=endDate]").val();
				var salesStartDate = $("input[name=salesStartDate]").val();
				var salesEndDate = $("input[name=salesEndDate]").val();
				var shopNo=$("#shopNo_select").val()=="-1"?"":$("#shopNo_select").val();
				var url = App.getContextPath()
						+ "admin/report/searchProductReport.do?productName="+productName+"&shopNo="+shopNo;
				if (startDate != "")
					url += "&startDate=" + startDate;
				if (endDate != "")
					url += "&endDate=" + $.dateAdd(endDate);
				if (salesStartDate != "")
					url += "&salesStartDate=" + salesStartDate;
				
				if (salesEndDate != "")
					url += "&salesEndDate=" + $.dateAdd(salesEndDate);
				
				if ($mainDataTable) {
					$mainDataTable.api().ajax.url(url).load();
					return;
				}
				var dtSetting = $.dataTableSetting({
					"ajaxSource" : url,
					"serverSide" : true,
					"bFilter" : false,// 去掉搜索框
					"bLengthChange" : true,// 每页显示数量							
					"sScrollX" : "100%",
					"sScrollXInner" : "100%",
					"iDisplayLength" : 25,

					"bSort" : false,
					"aoColumns" : [ {
						"mDataProp" : "productCode",
						"sTitle" : "商品编码",
						"width" : "10%"
					}, {
						"mDataProp" : "productName",
						"sTitle" : "前台商品名称",
						"width" : "10%"
					}, {
						"mDataProp" : "adminProductName",
						"sTitle" : "后台商品名称",
						"width" : "10%"
					}, {
						"sTitle" : "销售件数(支付)",
						"mDataProp" : "saleNum",
						"width" : "10%",
						"class" : "format_number"
					}, {
						"sTitle" : "操作",						
						"width" : "10%",
						"render":function(data, type, row){
							 var str="<a class='btn btn-warning btn-xs btn-width bt_shop' style='width:60px;margin-left:0px;margin-right:5px;margin-top:2px;' href='javascript:;' productCode="+row.productCode+"><i class='fa fa-arrow-circle-o-up'></i>按店铺</a>";
						
						     str+="<a class='btn btn-success btn-xs  btn-width bt_sku' style='margin-left:0px;margin-right:5px;margin-top:2px;' href='javascript:;' productCode="+row.productCode+" ><i class='fa fa-pencil-square-o'></i>按尺码</a>";
						   
						     return str;
							}
					} ]

				});

				$mainDataTable = $("#db_report_list").dataTable(dtSetting);
			};

			var exportOrder = function() {

				var strdiv = '<form id=export action='
						+ App.getContextPath()
						+ 'admin/order/exportOrder.do><input type=hidden name=startDate value='
						+ $("[name=startDate]").val()
						+ '><input type=hidden name=endDate value='
						+ $("[name=endDate]").val() + '></form>';

				$("body").append(strdiv);
				$("#export").submit();

			};
			var setSalesDate=function(){
				var $viewPanel=$("#form_Order");
				var startDate = $('.bootstrap-datepicker[name=salesStartDate]', $viewPanel).bsdatepicker({
					format: 'yyyy-mm-dd',
					autoclose: true,
					onRender: function(date) {
						var endDateStr = $('.bootstrap-datepicker[name=salesEndDate]', $viewPanel).val();				
						if(!endDateStr){
							return '';
						}				
						var ed = endDateStr.parseDate();			
						if(!ed) return '';				
					    return date.valueOf() > ed.valueOf() ? 'disabled' : '';
					}
			    });		
				//startDate.bsdatepicker("setValue","");
				startDate.on('changeDate', function(ev) {
			    	if (endDate && endDate.date && ev.date.valueOf() >= endDate.date.valueOf()) {
			    		var newDate = new Date(ev.date)
			    		newDate.setDate(newDate.getDate());
			    		
			    		endDate.bsdatepicker("setValue",newDate);
			    	}	    	
			    	var newDate = new Date()
		    		newDate.setDate(newDate.getDate());
			    	endDate.bsdatepicker("setValue",newDate);
			    	endDate.bsdatepicker("fill");
			    	startDate.bsdatepicker("hide");
			    });						
				var endDate = $('.bootstrap-datepicker[name=salesEndDate]', $viewPanel).bsdatepicker({
					format: 'yyyy-mm-dd',
					autoclose: true,
					onRender: function(date) {
						var startDateStr = $('.bootstrap-datepicker[name=salesStartDate]', $viewPanel).val();
						
						if(!startDateStr){
							return '';
						}
						var sd = startDateStr.parseDate();
						if(!sd) return '';
						
						return date.valueOf() < sd.valueOf() ? 'disabled' : '';
					}
			    });		
				//endDate.bsdatepicker("setValue","");
				endDate.on('changeDate', function(ev) {
			    	if (startDate && startDate.date && ev.date.valueOf() < startDate.date.valueOf()) {
			    		var newDate = new Date(ev.date)
			    		newDate.setDate(newDate.getDate());
			    		startDate.bsdatepicker("setValue",newDate);
			    	}	    	
			    	
			    	startDate.bsdatepicker("fill");
			    	endDate.bsdatepicker("hide");
			    });
				endDate.on("input",function(){
					startDate.bsdatepicker("fill");
				});
				startDate.on("input",function(){
					endDate.bsdatepicker("fill");
				});	
			}
			
			var getProductByShop=function(){
				var productCode=$(this).attr("productCode");
				var startDate = $("input[name=startDate]").val();
				var endDate = $("input[name=endDate]").val();
				var shopNo=$("#shopNo_select").val()!="-1"?$("#shopNo_select").val():"";
				
				$.ajax({
					type: "get",
					url: App.getContextPath() + "admin/report/getProductSalesByShop.do",
					data:{productCode:productCode,startDate:startDate,endDate:$.dateAdd(endDate),shopNo:shopNo},
					async: false,
					success: function(result) {
						if(result.length>0){
							$("#shop_config table tbody tr").remove();
							$.each(result,function(index,item){
								$("#shop_config table tbody").append("<tr><td>"+item.shopName+"</td><td>"+item.amount+"</td></tr>")
							});							
							$("#shop_config").modal("show");
							
						}
						
					}
					
				});
			}
			var getProductBySku=function(){
				var productCode=$(this).attr("productCode");
				var startDate = $("input[name=startDate]").val();
				var endDate = $("input[name=endDate]").val();
				$.ajax({
					type: "get",
					url: App.getContextPath() + "admin/report/getProductSalesBySku.do",
					data:{productCode:productCode,startDate:startDate,endDate:$.dateAdd(endDate)},
					async: true,
					success: function(result) {
						if(result!=""){
							$("#sku_config table tbody tr").remove();
							$.each(result,function(index,item){
								$("#sku_config table tbody").append("<tr><td>"+item.size+"</td><td>"+item.amount+"</td><td>"+item.stockAmount+"</td><td>"+item.purchaseAmount+"</td></tr>")
							});							
							$("#sku_config").modal("show");
							
						}
						
					}
					
				});
			}
			return {
				init : function() {
					$("#shopNo_select").select2();
					$.initDate($("#form_Order"), 0, 0);
					setSalesDate();
					$(".search").click(searchData);
					searchData();
					$("#db_report_list").on("click",".bt_shop",getProductByShop);
					$("#db_report_list").on("click",".bt_sku",getProductBySku);
					$(".export").click(function(){
						$("#form_Order").submit();
					});
					
				}
			}
		}();

		$(function() {
			$("#header").load("../head.html");
			App.init(); //Initialise plugins and elements	 
			Report.init();
		});
	</script>
	<!-- /JAVASCRIPTS -->
</body>
</html>